package com.roc.steelend.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.roc.steelend.controller.vo.returnformat.ReturnMsgForTable;
import com.roc.steelend.pojo.BuyOrder;
import io.swagger.models.auth.In;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.Date;
import java.util.HashMap;
import java.util.List;
import java.util.logging.Handler;

@Repository
public interface BuyOrderMapper extends BaseMapper<BuyOrder> {

      List<BuyOrder> findALlMsg(
                                @Param("bigTypeId")Integer bigTypeId, @Param("smallTypeId")Integer smallTypeId,
                                @Param("warehouseId")Integer warehouseId, @Param("specification")String specification,
                                @Param("supplierName")String supplierName, @Param("showAllPayInvoice")Boolean showAllPayInvoice,
                                @Param("showPay")Boolean showPay, @Param("showInvoice")Boolean showInvoice,
                                @Param("startDate")Date startDate,@Param("endDate")Date endDate);

      Integer buyFindRecodingCount(
                                   @Param("bigTypeId")Integer bigTypeId, @Param("smallTypeId")Integer smallTypeId,
                                   @Param("warehouseId")Integer warehouseId, @Param("specification")String specification,
                                   @Param("supplierName")String supplierName, @Param("showAllPayInvoice")Boolean showAllPayInvoice,
                                   @Param("showPay")Boolean showPay, @Param("showInvoice")Boolean showInvoice,
                                   @Param("startDate")Date startDate,@Param("endDate")Date endDate);


      Integer updateReconciliationBySuppliers(@Param("suppliers")Integer suppliers,
                                              @Param("reconciliationBuyId") BigInteger reconciliationBuyId);

      Integer updateTiaoPiaoBySuppliers(@Param("suppliers")Integer suppliers,
                                              @Param("tiaoPiaoBuyId") BigInteger tiaoPiaoBuyId);


      Integer selectByEchartsByPay();

      Integer selectByEchartsInvoice();

      List<HashMap<String,Object>> selectAllBuSuppliersId(@Param("suppliersId")Integer suppliersId);
      List<HashMap<String,Object>> selectAllBuSuppliersIdInovice(@Param("suppliersId")Integer suppliersId);







}
